Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TaxRegistrationTaxTypeID (PK) | A system assigned unique identifier for an assocation of tax registrations to jurisdictions and tax types. | ID_TX_RGST_TX_TYP | Identity | integer | |
EffectiveDateTime (AK) | The date & time from which the TaxJurisdiction recognizes the TaxRegistration. | TS_EF | EffectiveDateTime | datetime | |
TaxRegistrationID (AK)(FK) | A unique system assigned identifier for this TaxRegistration. | ID_RGST_TX | Identity | integer | TaxRegistration(PA_TX_RGST) |
TaxJurisdictionID (AK)(FK) | A unique system assigned identifier for the TaxJurisdiction. | ID_JRDT_TX | Identity | integer | TaxJurisdictionTaxType(RU_JRDT_TX_TYP_TX) |
TaxTypeCode (AK)(FK) | A retailer assigned mnemonic code denoting a kind of tax. Eg: SalesTax, GST, PST, HST, VAT | CD_TYP_TX | Code4 | char(4) | TaxJurisdictionTaxType(RU_JRDT_TX_TYP_TX) |
ExpirationDateTime | The date & time after which the TaxJurisdiction no longer recognizes the TaxRegistration. | TS_EP | ExpirationDateTime | datetime | |